<!DOCTYPE html>
<!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]-->
<!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]-->
<!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js"> <!--<![endif]-->
<head>
  <meta http-equiv="content-type" content="text/html; charset=utf-8">
  <title>Oracle存储过程与函数  &middot; sitename</title>
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="HandheldFriendly" content="True">
<meta name="MobileOptimized" content="320">
<meta name="viewport" content="width=device-width, initial-scale=1">


<meta name="description" content="Oracle存储过程与函数 description" />

<meta name="keywords" content="one, two, ">


<meta property="og:title" content="Oracle存储过程与函数  &middot; sitename ">
<meta property="og:site_name" content="sitename"/>
<meta property="og:url" content="https://lvzongcheng.gitee.io/sql/oracle%E5%AD%98%E5%82%A8%E8%BF%87%E7%A8%8B%E5%87%BD%E6%95%B0/" />
<meta property="og:locale" content="en-EN">


<meta property="og:type" content="article" />
<meta property="og:description" content="Oracle存储过程与函数 description"/>
<meta property="og:article:published_time" content="2017-05-13T00:00:00Z" />
<meta property="og:article:modified_time" content="2017-05-13T00:00:00Z" />

  
    
<meta property="og:article:tag" content="one">
    
<meta property="og:article:tag" content="two">
    
  

  

<script type="application/ld+json">
  {
    "@context": "http://schema.org",
    "@type": "Article",
    "headline": "Oracle存储过程与函数",
    "author": {
      "@type": "Person",
      "name": "LvZongCheng"
    },
    "datePublished": "2017-05-13",
    "description": "Oracle存储过程与函数 description",
    "wordCount":  402 
  }
</script>



<link rel="canonical" href="https://lvzongcheng.gitee.io/sql/oracle%E5%AD%98%E5%82%A8%E8%BF%87%E7%A8%8B%E5%87%BD%E6%95%B0/" />

<link rel="apple-touch-icon-precomposed" sizes="144x144" href="https://lvzongcheng.gitee.io/touch-icon-144-precomposed.png">
<link href="https://lvzongcheng.gitee.io/favicon.png" rel="icon">

<meta name="generator" content="Hugo 0.60.0" />

  <!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->

<link href='https://fonts.googleapis.com/css?family=Merriweather:300%7CRaleway%7COpen+Sans' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="/css/font-awesome.min.css">
<link rel="stylesheet" href="/css/style.css">
<link rel="stylesheet" href="/css/highlight/default.css">

  
  
	<script>
	  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
	  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
	  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
	  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');

	  ga('create', 'Your Google Analytics tracking code', 'auto');
	  ga('send', 'pageview');

	</script>

</head>
<body>
  <main id="main-wrapper" class="container main_wrapper has-sidebar">
    <header id="main-header" class="container main_header">
  <div class="container brand">
  <div class="container title h1-like">
  <a class="baselink" href="https://lvzongcheng.gitee.io">
  LvZongCheng

</a>

</div>

  
<div class="container topline">
  
  淡定 执著 进取 自律


</div>


</div>

  <nav class="container nav primary no-print">
  

<a class="homelink" href="https://lvzongcheng.gitee.io">home</a>


  
<a href="https://lvzongcheng.gitee.io/framework" title="Show list of Frameworks">Frameworks</a>

<a href="https://lvzongcheng.gitee.io/java" title="Show list of Java">Java</a>

<a href="https://lvzongcheng.gitee.io/linux" title="Show list of Linux">Linux</a>

<a href="https://lvzongcheng.gitee.io/redis" title="Show list of Redis">Redis</a>

<a href="https://lvzongcheng.gitee.io/sql" title="Show list of SQL">SQL</a>

<a href="https://lvzongcheng.gitee.io/Spring" title="Show list of Spring">Spring</a>

<a href="https://lvzongcheng.gitee.io/tools" title="Show list of Tools">Tools</a>

<a href="https://lvzongcheng.gitee.io/webpage" title="Show list of WebPage">WebPage</a>

<a href="https://lvzongcheng.gitee.io/information" title="Show list of information">information</a>

<a href="https://lvzongcheng.gitee.io/network" title="Show list of network">network</a>

<a href="https://lvzongcheng.gitee.io/%E5%BE%AE%E6%9C%8D%E5%8A%A1" title="Show list of 微服务">微服务</a>

<a href="https://lvzongcheng.gitee.io/%E6%80%BB%E7%BB%93" title="Show list of 总结">总结</a>

<a href="https://lvzongcheng.gitee.io/%E6%9C%BA%E5%99%A8%E8%87%AA%E5%8A%A8%E5%8C%96" title="Show list of 机器自动化">机器自动化</a>

<a href="https://lvzongcheng.gitee.io/%E6%B1%87%E7%BC%96" title="Show list of 汇编">汇编</a>

<a href="https://lvzongcheng.gitee.io/%E8%AE%B0%E4%BA%8B%E6%9C%AC" title="Show list of 记事本">记事本</a>


</nav>

<div class="container nav secondary no-print">
  
<a id="contact-link-email" class="contact_link" rel="me" aria-label="Email" href="mailto:Lyc19880405@163.com">
  <span class="fa fa-envelope-square"></span></a>



<a id="contact-link-github" class="contact_link" rel="me" aria-label="Github" href="https://github.com/enten/hugo-boilerplate">
  <span class="fa fa-github-square"></span></a>




 


















</div>


  

</header>


<article id="main-content" class="container main_content single">
  <header class="container hat">
  <h1>Oracle存储过程与函数
</h1>

</header>

  <div class="container content">
  <p>简单分类</p>
<p>                       |&mdash;-过程（存储过程）<br>
                       |&mdash;-函数<br>
快(编程)&mdash;&mdash;|<br>
                       |&mdash;-触发器<br>
                       |&mdash;-包</p>
<h4 id="heading">存储过程与函数区别</h4>
<h4 id="1--oracle-">1.  创建存储过程（加斜杠代表指定oracle 创建存储过程）</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-shell" data-lang="shell">create procedure 名称 is  
begin  
--执行部分  
end;  
/   
</code></pre></div><h4 id="2--">2.  创建或替换名称重复的存储过程</h4>
<pre><code>create or replace procedure 名称 is
begin
--执行部分
end;
/

 （注：replace 表示名称存在就替换）

create or replace procedure 名称（参数名1 [in/out] 类型，参数名2 [in] 类型....） is
begin
--执行部分
end;
/
  （注：参数输入或输出[in/out]默认是 in 输入,out 表示一个输出参数）
</code></pre><h4 id="3--show-error-">3.  show error; 查看错误</h4>
<h4 id="4--">4.  过程调用</h4>
<p>(1) exec 过程名（参数1，参数2&hellip;）<br>
(2) call 过程名（参数1，参数2&hellip;）</p>
<p>输出要先执行set serveroutput on
否则执行成功，控制台没有打印数据</p>
<p>exec与call区别：</p>
<h4 id="5--">5.  标识符号的命名规范</h4>
<ol>
<li>定义变量时，建议用v_作为前缀</li>
<li>定义常量时，建议用c_作为前缀</li>
<li>定义游标时，建议用_cursor作为后缀</li>
<li>定义例外时，建议用e_作为前缀</li>
</ol>
<h4 id="6--">6.  块定由三个部分构成</h4>
<pre><code>declear
/*定义部分---定义常量、变量、游标、例外、复杂数据类型*/
begin
/*执行部分---要执行的pl/sql语句和sql语句*/
exception
/*例外处理部分---处理运行的各种错误*/
</code></pre><p>declear和exception部分是可选的</p>
<h4 id="7--dbmsoutput-oracle">7.  dbms_output 是oracle提供的包，包含一些过程。</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql">dbms_output.put_line(<span style="color:#e6db74">&#39;</span><span style="color:#e6db74">输出</span><span style="color:#e6db74">&#39;</span>) <span style="color:#960050;background-color:#1e0010">控</span><span style="color:#960050;background-color:#1e0010">制</span><span style="color:#960050;background-color:#1e0010">台</span><span style="color:#960050;background-color:#1e0010">输</span><span style="color:#960050;background-color:#1e0010">出</span><span style="color:#960050;background-color:#1e0010">打</span><span style="color:#960050;background-color:#1e0010">印</span>
<span style="color:#66d9ef">set</span> serveroutput <span style="color:#66d9ef">off</span> <span style="color:#960050;background-color:#1e0010">关</span><span style="color:#960050;background-color:#1e0010">闭</span><span style="color:#960050;background-color:#1e0010">输</span><span style="color:#960050;background-color:#1e0010">出</span>
<span style="color:#66d9ef">set</span> serveroutput <span style="color:#66d9ef">on</span> <span style="color:#960050;background-color:#1e0010">打</span><span style="color:#960050;background-color:#1e0010">开</span><span style="color:#960050;background-color:#1e0010">输</span><span style="color:#960050;background-color:#1e0010">出</span>
</code></pre></div><h4 id="8---">8.  &amp; 表示要接收从控制台输入的变量（&amp;变量）</h4>
<p>into 变量  查询出来的值赋值给 v_ename 变量</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">select</span> ename <span style="color:#66d9ef">into</span> v_ename <span style="color:#66d9ef">from</span> emp <span style="color:#66d9ef">where</span> empno<span style="color:#f92672">=</span><span style="color:#f92672">&amp;</span><span style="color:#66d9ef">no</span>;
</code></pre></div><p>|| 字符连接</p>
<h4 id="9--oralce-">9.  oralce 预定义例外</h4>
<p>no_data_found 找不到数据例外</p>
<p>exception</p>
<p>when no_data_found then 异常处理逻辑</p>
<h4 id="10--">10.  存储过程</h4>
<p>存储过程将变量定义在 IS 后就可以了</p>
<h4 id="11--java-">11.  java 调用存储过程</h4>
<ol>
<li>加载驱动</li>
</ol>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">Class<span style="color:#f92672">.</span><span style="color:#a6e22e">forName</span><span style="color:#f92672">(</span><span style="color:#e6db74">&#34;oracle.jdbc.driver.OracleDriver&#34;</span><span style="color:#f92672">)</span><span style="color:#f92672">;</span>
</code></pre></div><ol start="2">
<li>得到连接</li>
</ol>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">Connection ct<span style="color:#f92672">=</span>DriverManager<span style="color:#f92672">.</span><span style="color:#a6e22e">getConnection</span><span style="color:#f92672">(</span><span style="color:#e6db74">&#34;jdbc:oracle:thin:@&#34;</span><span style="color:#f92672">,</span><span style="color:#e6db74">&#34;&#34;</span><span style="color:#f92672">,</span><span style="color:#e6db74">&#34;&#34;</span><span style="color:#f92672">)</span><span style="color:#f92672">;</span>
</code></pre></div><ol start="3">
<li>创建 CallableStaatement</li>
</ol>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">CallableStatement cs<span style="color:#f92672">=</span>ct<span style="color:#f92672">.</span><span style="color:#a6e22e">prepareCall</span><span style="color:#f92672">(</span><span style="color:#e6db74">&#34;{call 过程名称(?,?)}&#34;</span><span style="color:#f92672">)</span><span style="color:#f92672">;</span>
</code></pre></div><p><code>注：参数用问号代替，几个问号代表几个参数</code></p>
<ol start="4">
<li>给？赋值(1、2代表第几个问号)</li>
</ol>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">cs<span style="color:#f92672">.</span><span style="color:#a6e22e">setString</span><span style="color:#f92672">(</span>1<span style="color:#f92672">,</span>值<span style="color:#f92672">)</span><span style="color:#f92672">;</span>
cs<span style="color:#f92672">.</span><span style="color:#a6e22e">setInt</span><span style="color:#f92672">(</span>2<span style="color:#f92672">,</span>值<span style="color:#f92672">)</span><span style="color:#f92672">;</span>
</code></pre></div><ol start="5">
<li>执行</li>
</ol>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">cs<span style="color:#f92672">.</span><span style="color:#a6e22e">execute</span><span style="color:#f92672">(</span><span style="color:#f92672">)</span><span style="color:#f92672">;</span>
</code></pre></div><ol start="6">
<li>关闭</li>
</ol>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">cs<span style="color:#f92672">.</span><span style="color:#a6e22e">close</span><span style="color:#f92672">(</span><span style="color:#f92672">)</span><span style="color:#f92672">;</span>
ct<span style="color:#f92672">.</span><span style="color:#a6e22e">close</span><span style="color:#f92672">(</span><span style="color:#f92672">)</span><span style="color:#f92672">;</span>
</code></pre></div><h6 id="heading1">调用有返回值的存储过程</h6>
<p>比如第二个问号有一个varcher 类型返回值
给第二个？赋值方法</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">cs<span style="color:#f92672">.</span><span style="color:#a6e22e">registerOutParameter</span><span style="color:#f92672">(</span>2<span style="color:#f92672">,</span>oracle<span style="color:#f92672">.</span><span style="color:#a6e22e">jdbc</span><span style="color:#f92672">.</span><span style="color:#a6e22e">OracleTypes</span><span style="color:#f92672">.</span><span style="color:#a6e22e">VARCHAR</span><span style="color:#f92672">)</span><span style="color:#f92672">;</span>
</code></pre></div><p>取出返回值(取出返回值要注意问号顺序，2就是代表第二个问号);</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">String name<span style="color:#f92672">=</span>cs<span style="color:#f92672">.</span><span style="color:#a6e22e">getString</span><span style="color:#f92672">(</span>2<span style="color:#f92672">)</span><span style="color:#f92672">;</span>
</code></pre></div><p>其他不变</p>
<h6 id="heading2">返回结果集的过程</h6>
<ul>
<li><strong>（1）、</strong>  创建包，在该包中，定义了类型test_cursor,是个游标</li>
</ul>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">create</span> <span style="color:#66d9ef">or</span> <span style="color:#66d9ef">replace</span> package tespackage <span style="color:#66d9ef">as</span>
<span style="color:#66d9ef">type</span> test_cursor <span style="color:#66d9ef">is</span> <span style="color:#66d9ef">ref</span> <span style="color:#66d9ef">cursor</span>;
<span style="color:#66d9ef">end</span> testpackage;
</code></pre></div><ul>
<li><strong>（2）、</strong>  创建过程</li>
</ul>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">create</span> <span style="color:#66d9ef">or</span> <span style="color:#66d9ef">replace</span> <span style="color:#66d9ef">procedure</span> sp_pro9
(spNo <span style="color:#66d9ef">in</span> njmber,p_cursor <span style="color:#66d9ef">out</span> tespackage.test_cursor)<span style="color:#66d9ef">is</span>
<span style="color:#66d9ef">begin</span>
 <span style="color:#66d9ef">open</span> p_cursor <span style="color:#66d9ef">for</span> <span style="color:#66d9ef">select</span><span style="color:#f92672">*</span><span style="color:#66d9ef">from</span> emp <span style="color:#66d9ef">where</span> depton<span style="color:#f92672">=</span>spNo;
<span style="color:#66d9ef">end</span>;
</code></pre></div><ul>
<li><strong>（3）、</strong>  如何在java中调用该过程</li>
</ul>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">cs<span style="color:#f92672">.</span><span style="color:#a6e22e">setInt</span><span style="color:#f92672">(</span>1<span style="color:#f92672">,</span>10<span style="color:#f92672">)</span><span style="color:#f92672">;</span>
cs<span style="color:#f92672">.</span><span style="color:#a6e22e">registerOutParameter</span><span style="color:#f92672">(</span>2<span style="color:#f92672">,</span>oracle<span style="color:#f92672">.</span><span style="color:#a6e22e">jdbc</span><span style="color:#f92672">.</span><span style="color:#a6e22e">OracleTypes</span><span style="color:#f92672">.</span><span style="color:#a6e22e">CURSOR</span><span style="color:#f92672">)</span><span style="color:#f92672">;</span>
cs<span style="color:#f92672">.</span><span style="color:#a6e22e">execute</span><span style="color:#f92672">(</span><span style="color:#f92672">)</span><span style="color:#f92672">;</span>
<span style="color:#75715e">//得到结果集
</span><span style="color:#75715e"></span>ResultSet rs<span style="color:#f92672">=</span><span style="color:#f92672">(</span>ResultSet<span style="color:#f92672">)</span>cs<span style="color:#f92672">.</span><span style="color:#a6e22e">getObject</span><span style="color:#f92672">(</span>2<span style="color:#f92672">)</span><span style="color:#f92672">;</span>
<span style="color:#66d9ef">while</span><span style="color:#f92672">(</span>rs<span style="color:#f92672">.</span><span style="color:#a6e22e">next</span><span style="color:#f92672">)</span><span style="color:#f92672">{</span>
rs<span style="color:#f92672">.</span><span style="color:#a6e22e">getInt</span><span style="color:#f92672">(</span>1<span style="color:#f92672">)</span><span style="color:#f92672">;</span>
rs<span style="color:#f92672">.</span><span style="color:#a6e22e">getString</span><span style="color:#f92672">(</span>2<span style="color:#f92672">)</span><span style="color:#f92672">;</span>
<span style="color:#f92672">}</span>
</code></pre></div><h4 id="12">12.函数</h4>
<p>函数用于返回特定的数据（一般返回一个值），在建立函数时，在函数头部必须包含return子句，而在
函数体内必须包含return语句返回的数据。可以用 create function 来建立函数</p>
<pre><code>create function 函数名称(参数1 类型....)
 return 返回值类型
is
变量名 变量类型；
begin
--执行部分
return 返回值;
end
</code></pre><p>其他和快一样，sql中和oracle直定义函数调用一样调用</p>
<h4 id="13">13.包</h4>
<p>包用于在逻辑上组合过程和函数，它由包规范和包体两部分组成。</p>
<p>使用 create package 来创建包</p>
<p>创建了一个包
声明该包有一个过程和一个函数</p>
<pre><code>create package 包名 is
 procedure 过程名(参数1 类型,.....)；
 frunction 函数名(参数 类型)return 返回类型；
end;
</code></pre><p>给包实现包体</p>
<pre><code>create package body 要实现包的名称 is

procedure 过程名称（参数 类型，....）
is
begin
end

function 函数名称（参数 类型）
return 返回类型
is
[定义变量;]
begin
return 变量;
end;
end;
</code></pre><h4 id="14--">14.  包的调用</h4>
<p>call 包体.函数或过程；</p>
<h4 id="15--">15.  触发器</h4>
<p>指隐含的存储过程。
create trigger 来建立触发器</p>
<p>常用触发事件
insert、update、delete</p>
<h4 id="16--">16.  定义并使用变量</h4>
<ol>
<li>标量类型(scalar)</li>
<li>复合类型(composite)</li>
<li>参照类型(reference)</li>
<li>lob(large object)</li>
</ol>
<h5 id="heading3">标量定义案例(其他还有)</h5>
<h6 id="heading4">定义一个变长字符串</h6>
<p>v_ename varchar2(10);</p>
<h6 id="999999999999">定义一个小数，范围-9999.99~9999.99</h6>
<p>v_sal number(6,2);</p>
<h6 id="false">定义一个布尔变量，不能为空，初始值为false。</h6>
<p>v_valid boolean not null default false;</p>
<h6 id="heading5">变量定义</h6>
<p>v_ename 表名.字段%type  变量大小与字段类型大小保持一至。</p>
<h5 id="composite">复合变量(composite)</h5>
<p>用于存放多个值的变量
(1).pl/sql记录  类似与高级语言中的结构体（javaBean）
(2).pl/sql表 相当于高级语言中的数组（下表没有限制可以为负数）
(3).嵌套表
(4).varray</p>
<p>pl/sql记录实例：</p>
<pre><code>   declare
   --定义一个pl/sql记录类型
   type 记录类型名称 is record(变量名称1 表名.字段%type,....);
   
   变量名称  记录类型名称;
   begin
   还是用into 给记录类型赋值
   end;
</code></pre><p>pl/sql表实例：</p>
<pre><code>   --定义了一个pl/sql表类型(表类型名称)  ,该类型用于存放(表名.字段%type)
   --index by binary_integer 表示下标是整数（有正负）
   type 表类型名称 is table of 表名.字段%type index by binary_integer;
   
   变量名称  表类型名称;
    begin
          into 变量名称(下标) 返回单行
    end;
</code></pre><h6 id="heading6">参照变量</h6>
<pre><code>     declare
     --定义游标类型
     type 游标类型名称 is ref cursor;
     --定义一个游标变量
     游标变量名称  游标类型名称；
     begin
     open 游标变量名称 for 查询语句
     --循环取出
     loop
     fetch 游标变量名称 into 变量1，变量2....;
     --判断退出条件 判断游标变量名称为空
     exit when 游标变量名称 %notfound;
     end loop;
     --关闭游标
     close 游标变量名称;
     end;


    while 条件 loop
    end loop;
</code></pre><h4 id="17--">17.  自定义例外</h4>
<p>例外变量名称 exception;</p>
<p>sql%notfound 表示没有更新（update）</p>
<p>raise 例外变量名称；触发例外</p>

</div>


  
</article>
      <footer id="main-footer" class="container main_footer">
  

  <div class="container nav foot no-print">
  
<a href="https://lvzongcheng.gitee.io/license">license</a>


  <a class="toplink" href="#">back to top</a>

</div>

  <div class="container credits">
  
<div class="container footline">
  
  code with <!-- raw HTML omitted --><!-- raw HTML omitted -->


</div>


  
<div class="container copyright">
  
  (c) 2015 yourname.


</div>


</div>

</footer>

    </main>
    
<script type="text/javascript">
  (function() {
    
    
    if (window.location.hostname == "localhost")
      return;
    var dsq = document.createElement('script'); dsq.async = true; dsq.type = 'text/javascript';
    dsq.src = '//your_disqus_shortname.disqus.com/count.js';
    (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
  })();
</script>



<script src="/js/highlight.pack.js"></script>
<script>hljs.initHighlightingOnLoad();</script>



    
  </body>
</html>

